﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;

namespace iMall.AtoZ.Helper
{
    public class LoadTraceSqlDAL : IDAL<LoadTraceEntity>
    {
        public bool Insert(LoadTraceEntity entity)
        {
            string SQLCommand = AtoZUtility.GetInserSql("LoadTrace", entity);

            List<SqlParameter> parameters = new List<SqlParameter>();

            SqlDALHelper.ExecuteSQLNonQuery(SQLCommand, parameters.ToArray());
            return true;
        }


        public bool Upadte(LoadTraceEntity entity)
        {
            string SQLCommand = AtoZUtility.GetUpdateSql("LoadTrace", entity);

            List<SqlParameter> parameters = new List<SqlParameter>();

            SqlDALHelper.ExecuteSQLNonQuery(SQLCommand, parameters.ToArray());
            return true;
        }

        public bool Delete ( int id )
        {
            throw new NotImplementedException();
        }

        public LoadTraceEntity GetByID ( int id )
        {
            throw new NotImplementedException();
        }

        public List<LoadTraceEntity> GetAll ( )
        {
            throw new NotImplementedException();
        }

        public List<LoadTraceEntity> GetByBatchID ( Guid batchID )
        {
            throw new NotImplementedException();
        }
    }
}